Tabela PatientTumour

Definicja tabeli PatientTumour

Name

PatientTumour

Code

PatientTumour

Comment

Nowotwór pacjenta


Lista kolumn tabeli PatientTumour

Name

Code

PatientTumourID

PatientTumourID

PatientID

PatientID

ICDID

ICDID

DiagnosisDT

DiagnosisDT

Active

Active


Kolumna PatientTumourID tabeli PatientTumour

Definicja kolumny PatientTumourID tabeli PatientTumour

Name

PatientTumourID

Code

PatientTumourID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID nowotworu pacjenta


Kolumna PatientID tabeli PatientTumour

Definicja kolumny PatientID tabeli PatientTumour

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID pacjenta


Kolumna ICDID tabeli PatientTumour

Definicja kolumny ICDID tabeli PatientTumour

Name

ICDID

Code

ICDID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Diagnoza ICD10. Diagnoza ogólna nowotworu.


Kolumna DiagnosisDT tabeli PatientTumour

Definicja kolumny DiagnosisDT tabeli PatientTumour

Name

DiagnosisDT

Code

DiagnosisDT

Data Type

DATE

Mandatory

No

Comment

Data rozpoznania


Kolumna Active tabeli PatientTumour

Definicja kolumny Active tabeli PatientTumour

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

Yes

Comment

0 oznacza usunieta pozycje


Lista kluczy tabeli PatientTumour

Name

Code

Primary

PK_PatientTumour

PK_PatientTumour

X


Klucz PK_PatientTumour tabeli PatientTumour

Definicja klucza PK_PatientTumour tabeli PatientTumour

Name

PK_PatientTumour

Code

PK_PatientTumour

Primary

Yes

Comment